package com.ben.multiple.shard.springjdbc.mp;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ben.multiple.shard.springjdbc.dto.ModelVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface ModelMapper extends BaseMapper<Model> {

    @Select("select tm.model_id,tm.model_name,tmd.remark remark from t_model tm left join t_model_detail tmd on tm.model_id = tmd.model_id")
    List<ModelVO> queryBind();
}
